﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'userDelete')
	BEGIN
		DROP  Procedure  userDelete
	END
GO

CREATE PROCEDURE [dbo].[userDelete]
	-- Add the parameters for the stored procedure here
	@user_id INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	DELETE FROM lit_usuario_rol WHERE lit_usuario_id = @user_id;
	DELETE FROM lit_usuario WHERE lit_usuario_id = @user_id;

END
GO 